﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'PaisGetList')
	BEGIN
		DROP  Procedure  PaisGetList
	END
GO

CREATE PROCEDURE PaisGetList 	
	(	
		@empresaId AS INT,		
		@filtro AS VARCHAR(50) = NULL
	)	
AS
BEGIN	
	SET NOCOUNT ON
	
	SELECT PaisId AS Id, Nombre 
	FROM Pais
	WHERE Nombre like '%' + ISNULL(@filtro,'') + '%'	  

	SET NOCOUNT OFF
END
GO

 